home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgLangD.iso / Borland Visual dBASE Professiona v7.0 / DATA1.CAB / Sample_dBASE / Fleet / Ftree.sql < prev    next >
Text File  |  1997-11-20  |  452b  |  7 lines
  1. --Database:FLEET
  2. SELECT Aircraft."Aircraft ID", Aircraft.MAKE, Aircraft.MODEL, Schedule."Aircraft ID", Schedule."Flight Date", Schedule."Flight ID", Flight."Flight ID", Flight."From ID", Flight."To ID", Flight.DEPARTS, Flight.ARRIVES
  3. FROM "schedule.dbf" Schedule
  4.    INNER JOIN "flight.dbf" Flight
  5.    ON  (Schedule."Flight ID" = Flight."Flight ID")  
  6.    INNER JOIN "aircraft.dbf" Aircraft
  7.    ON  (Schedule."Aircraft ID" = Aircraft."Aircraft ID")